-- =============================================
-- Author:		<Huynh Quoc Thanh>
-- Create date: <26/01/2010>
-- Description:	<Update status of specific timesheet record by ID>
-- =============================================
USE TimeSheet
GO

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'usp_UpdateTimeSheetStatusByTimeSheetID')
	DROP PROCEDURE usp_UpdateTimeSheetStatusByTimeSheetID
GO
CREATE PROCEDURE usp_UpdateTimeSheetStatusByTimeSheetID
	-- Declare parameters for the procedure.
	@TimeSheetID BIGINT,
	@StatusID INT
AS
BEGIN
	UPDATE TS_TimeSheet SET StatusID = @StatusID WHERE TimeSheetID = @TimeSheetID
END 